#ifndef DBTABCLASSIFIERPRODUCT_H
#define DBTABCLASSIFIERPRODUCT_H

#include "dbtabbase.h"
class DBTabClassifierProduct:public DBTabBase
{
public:
    DBTabClassifierProduct();
    static DBTabClassifierProduct* getDBTab(){
        static DBTabClassifierProduct tab;
        return &tab;
    }
    static const ColumnInfo mColumnTab[];
    static const QLatin1String TAB_NAME;
    static const char* _NAME;
    static const char* _BARCODE;

    static const char* _R1_LOW;
    static const char* _R1_HI;
    static const char* _R2_LOW;
    static const char* _R2_HI;
    static const char* _R3_LOW;
    static const char* _R3_HI;
    static const char* _R4_LOW;
    static const char* _R4_HI;
    static const char* _R5_LOW;
    static const char* _R5_HI;
    static const char* _R6_LOW;
    static const char* _R6_HI;
    static const char* _R7_LOW;
    static const char* _R7_HI;
    static const char* _R8_LOW;
    static const char* _R8_HI;
    static const char* _R9_LOW;
    static const char* _R9_HI;
    static const char* _R10_LOW;
    static const char* _R10_HI;
    static const char* _R11_LOW;
    static const char* _R11_HI;
    static const char* _R12_LOW;
    static const char* _R12_HI;

    enum{
        INDEX_ID,
        INDEX_NAME,
        INDEX_BARCODE,
        INDEX_R1_LOW,
        INDEX_R1_HI,
        INDEX_R2_LOW,
        INDEX_R2_HI,
        INDEX_R3_LOW,
        INDEX_R3_HI,
        INDEX_R4_LOW,
        INDEX_R4_HI,
        INDEX_R5_LOW,
        INDEX_R5_HI,
        INDEX_R6_LOW,
        INDEX_R6_HI,
        INDEX_R7_LOW,
        INDEX_R7_HI,
        INDEX_R8_LOW,
        INDEX_R8_HI,
        INDEX_R9_LOW,
        INDEX_R9_HI,
        INDEX_R10_LOW,
        INDEX_R10_HI,
        INDEX_R11_LOW,
        INDEX_R11_HI,
        INDEX_R12_LOW,
        INDEX_R12_HI,
        INDEX_END
    };
    static const char *getColumnName(int index);
    void createTab(QSqlDatabase &db);
};

#endif // DBTABCLASSIFIERPRODUCT_H
